/*
MySQL Backup
Database: yiji
Backup Time: 2021-11-15 11:23:49
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `yiji`.`address`;
DROP TABLE IF EXISTS `yiji`.`com_like`;
DROP TABLE IF EXISTS `yiji`.`favorites`;
DROP TABLE IF EXISTS `yiji`.`goods`;
DROP TABLE IF EXISTS `yiji`.`goods_eval`;
DROP TABLE IF EXISTS `yiji`.`like_tb`;
DROP TABLE IF EXISTS `yiji`.`order_details`;
DROP TABLE IF EXISTS `yiji`.`orders`;
DROP TABLE IF EXISTS `yiji`.`p_comm`;
DROP TABLE IF EXISTS `yiji`.`pics`;
DROP TABLE IF EXISTS `yiji`.`shopcart`;
DROP TABLE IF EXISTS `yiji`.`theme_design`;
DROP TABLE IF EXISTS `yiji`.`theme_maincom`;
DROP TABLE IF EXISTS `yiji`.`user`;
CREATE TABLE `address` (
  `address_id` int(20) NOT NULL AUTO_INCREMENT,
  `address_prov` varchar(255) DEFAULT NULL,
  `address_name` varchar(255) DEFAULT NULL,
  `address_phone` char(11) DEFAULT NULL,
  `address_status` int(1) DEFAULT NULL,
  `user_id` int(20) NOT NULL,
  `address_city` varchar(255) DEFAULT NULL,
  `address_district` varchar(255) DEFAULT NULL,
  `address_details` varchar(255) DEFAULT NULL,
  `address_area` varchar(255) DEFAULT NULL,
  `adds_default` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`address_id`) USING BTREE,
  KEY `fk_address_user_1` (`user_id`) USING BTREE,
  CONSTRAINT `fk_address_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `com_like` (
  `com_like_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_comm_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `color` varchar(255) NOT NULL,
  PRIMARY KEY (`com_like_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `favorites` (
  `favorite_id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT NULL,
  `favorite_time` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `goods_id` int(20) NOT NULL,
  `goods_img` varchar(255) DEFAULT NULL,
  `goods_price` decimal(10,2) DEFAULT NULL,
  `goods_title` varchar(255) DEFAULT NULL,
  `favorite_state` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`favorite_id`) USING BTREE,
  KEY `fk_favorites_user_1` (`user_id`) USING BTREE,
  KEY `fk_favorites_goods_1` (`goods_id`) USING BTREE,
  CONSTRAINT `fk_favorites_goods_1` FOREIGN KEY (`goods_id`) REFERENCES `goods` (`goods_id`),
  CONSTRAINT `fk_favorites_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=690 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `goods` (
  `goods_id` int(20) NOT NULL,
  `goods_title` varchar(255) NOT NULL,
  `goods_details` varchar(255) DEFAULT NULL,
  `goods_price` varchar(255) NOT NULL,
  `goods_scire` float(1,1) DEFAULT NULL,
  `is_delete` bit(1) NOT NULL,
  `goods_img` varchar(255) NOT NULL,
  `goods_date` datetime DEFAULT NULL,
  `goods_discount` bit(1) DEFAULT NULL,
  `goods_sales` int(255) DEFAULT NULL,
  `goods_collection` int(255) DEFAULT NULL,
  `goods_browse` int(255) DEFAULT NULL,
  `goods_size` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`goods_id`) USING BTREE,
  KEY `goods_img` (`goods_img`),
  KEY `goods_price` (`goods_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `goods_eval` (
  `goods_eval_id` int(20) NOT NULL,
  `goods_id` int(20) NOT NULL,
  `user_id` int(20) NOT NULL,
  `goods_eval_cont` varchar(255) DEFAULT NULL,
  `goods_eval_time` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `goods_eval_stars` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`goods_eval_id`) USING BTREE,
  KEY `fk_goods_eval_user_1` (`user_id`) USING BTREE,
  KEY `fk_goods_eval_order_details_1` (`goods_id`) USING BTREE,
  CONSTRAINT `fk_goods_eval_order_details_1` FOREIGN KEY (`goods_id`) REFERENCES `order_details` (`orders_goodsid`),
  CONSTRAINT `fk_goods_eval_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `like_tb` (
  `like_id` int(20) NOT NULL AUTO_INCREMENT,
  `theme_id` int(20) DEFAULT NULL,
  `user_id` int(20) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`like_id`),
  KEY `theme_id` (`theme_id`),
  CONSTRAINT `like_tb_ibfk_1` FOREIGN KEY (`theme_id`) REFERENCES `theme_design` (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=373 DEFAULT CHARSET=utf8;
CREATE TABLE `order_details` (
  `orders_id` int(20) NOT NULL,
  `orders_count` int(10) DEFAULT NULL,
  `logi_status` varchar(255) DEFAULT NULL,
  `orders_status` varchar(255) DEFAULT NULL,
  `orders_message` varchar(255) DEFAULT NULL,
  `logi_oddNum` varchar(255) DEFAULT NULL,
  `orders_delivery_Time` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `orders_receiving_Time` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `orders_startTime` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `shipment_status` varchar(255) DEFAULT NULL,
  `orders_goodsid` int(20) NOT NULL,
  PRIMARY KEY (`orders_id`) USING BTREE,
  KEY `fk_order_details_orders_2` (`orders_goodsid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `orders` (
  `orders_id` int(20) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `orders_addressID` int(20) DEFAULT NULL,
  `orders_total` float(20,2) DEFAULT NULL,
  `user_id` int(20) NOT NULL,
  `orders_goodsid` int(20) DEFAULT NULL,
  `orders_goods_img` varchar(255) DEFAULT NULL,
  `orders_goods_title` varchar(255) DEFAULT NULL,
  `orders_goods_price` decimal(10,2) DEFAULT NULL,
  `orders_goods_count` int(255) DEFAULT NULL,
  `orders_goods_size` varchar(255) DEFAULT NULL,
  `orders_pay_state` tinyint(1) DEFAULT '0',
  `orders_payed_view_state` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`orders_id`) USING BTREE,
  KEY `fk_orders_user_1` (`user_id`) USING BTREE,
  KEY `fk_orders_goods_1` (`orders_goodsid`) USING BTREE,
  CONSTRAINT `fk_orders_goods_1` FOREIGN KEY (`orders_goodsid`) REFERENCES `goods` (`goods_id`),
  CONSTRAINT `fk_orders_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1246 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `p_comm` (
  `product_comm_id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT NULL,
  `goods_id` int(20) DEFAULT NULL,
  `product_detail` varchar(255) DEFAULT NULL,
  `product_data` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `state` int(1) unsigned zerofill DEFAULT '0',
  `like_count` int(255) DEFAULT NULL,
  `user_name` varchar(30) DEFAULT NULL,
  `user_pic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`product_comm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
CREATE TABLE `pics` (
  `pic_id` int(20) NOT NULL,
  `goods_id` int(20) NOT NULL,
  `pic_url` varchar(255) NOT NULL,
  PRIMARY KEY (`pic_id`) USING BTREE,
  KEY `fk_pics_goods_1` (`goods_id`) USING BTREE,
  CONSTRAINT `fk_pics_goods_1` FOREIGN KEY (`goods_id`) REFERENCES `goods` (`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `shopcart` (
  `shopcart_id` int(20) NOT NULL AUTO_INCREMENT,
  `shopcart_count` int(20) DEFAULT '1',
  `shopcart_attribute` varchar(255) DEFAULT NULL,
  `shopcart_goodsID` int(20) NOT NULL,
  `user_id` int(20) DEFAULT NULL,
  `shopcart_addTime` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `shopcart_goods_img` varchar(255) DEFAULT NULL,
  `shopcart_goods_price` decimal(10,2) DEFAULT NULL,
  `shopcart_goods_title` varchar(255) DEFAULT NULL,
  `checked` tinyint(1) DEFAULT '0',
  `shopcart_goods_size` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`shopcart_id`) USING BTREE,
  KEY `fk_shopcart_goods_1` (`shopcart_goodsID`) USING BTREE,
  KEY `fk_shopcart_user_1` (`user_id`) USING BTREE,
  KEY `shopcart_goods_img` (`shopcart_goods_img`),
  CONSTRAINT `fk_shopcart_goods_1` FOREIGN KEY (`shopcart_goodsID`) REFERENCES `goods` (`goods_id`),
  CONSTRAINT `fk_shopcart_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=382 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `theme_design` (
  `theme_id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) DEFAULT NULL,
  `theme_title` varchar(255) NOT NULL,
  `pic_url` varchar(255) DEFAULT NULL,
  `like_count` int(20) DEFAULT NULL,
  `com_count` int(20) DEFAULT NULL,
  `collection_count` int(20) DEFAULT NULL,
  `forward_count` tinyint(1) DEFAULT NULL,
  `is_forward` bit(1) DEFAULT NULL,
  `forward_id` int(20) DEFAULT NULL,
  `start_time` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `theme_content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`theme_id`) USING BTREE,
  KEY `fk_theme_design_user_1` (`user_id`) USING BTREE,
  CONSTRAINT `fk_theme_design_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `theme_maincom` (
  `theme_mainCom_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `theme_id` int(11) DEFAULT NULL,
  `com_content` text,
  `com_time` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `like_count` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_pic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`theme_mainCom_id`) USING BTREE,
  KEY `fk_theme_mainCom_theme_design_1` (`theme_id`) USING BTREE,
  CONSTRAINT `theme_maincom_ibfk_1` FOREIGN KEY (`theme_id`) REFERENCES `theme_design` (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `user` (
  `user_id` int(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(30) NOT NULL,
  `user_phone` char(11) NOT NULL,
  `user_sex` varchar(255) DEFAULT NULL,
  `user_pwd` varchar(255) NOT NULL,
  `user_email` varchar(255) DEFAULT NULL,
  `user_height` int(3) DEFAULT NULL,
  `user_weight` int(10) DEFAULT NULL,
  `user_birth` varchar(255) DEFAULT NULL,
  `user_point` int(20) DEFAULT NULL,
  `user_pic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
BEGIN;
LOCK TABLES `yiji`.`address` WRITE;
DELETE FROM `yiji`.`address`;
INSERT INTO `yiji`.`address` (`address_id`,`address_prov`,`address_name`,`address_phone`,`address_status`,`user_id`,`address_city`,`address_district`,`address_details`,`address_area`,`adds_default`) VALUES (48, '江苏', '何', '18036109573', NULL, 27, '苏州', NULL, '江苏省苏州市', NULL, 0),(65, '北京', '何佳惠', '18795720289', NULL, 16, '西城区', NULL, '就看见空间', NULL, 0),(72, '广东', '水电费水电费是发送到发是', '12222222222', NULL, 15, '深圳', NULL, '奥术', '罗湖区', 0),(73, NULL, '胜多负少', '10000000000', NULL, 15, NULL, NULL, '地方v', NULL, 0),(75, NULL, '', '12345676787', NULL, 16, NULL, NULL, '', NULL, 0),(76, '广东', '从德赛电池v', '10000000000', NULL, 15, '深圳', NULL, '程序对方vdf', '罗湖区', 0),(77, '广东', '五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市', '10909090909', NULL, 15, '深圳', NULL, '五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市五常市', '福田区', 0),(78, '广东', '赫赫', '13987875647', NULL, 16, '深圳', NULL, '急急急急急急急急急', '南山区', 0),(79, '广东', '瓦达', '11131111111', NULL, 23, '深圳', NULL, '11111111111', '罗湖区', 1),(80, '重庆', '绘卷', '11111111111', NULL, 23, '北碚区', NULL, '安安生生所所所', NULL, 0),(83, '北京', '汪星成', '18913526213', NULL, 32, '东城区', NULL, '123123', NULL, 0),(84, '广东', '汪星成', '18913526213', NULL, 32, '广州', NULL, '少时诵诗书', '越秀区', 0),(87, '北京', '汪星成', '18913526213', NULL, 32, '西城区', NULL, '球球求求群群888', NULL, 0),(88, '天津', '汪星成', '18913526213', NULL, 32, '河西区', NULL, '123123123123123', NULL, 0),(89, '黑龙江', '邵', '15150137501', NULL, 15, '哈尔滨', NULL, '山河 ', '五常市', 0),(90, '江苏', '何佳慧', '18795720289', NULL, 27, '南通', NULL, '江苏省南通市海门市', '海门市', 0),(91, '上海', '何哈哈', '18098837283', NULL, 27, '徐汇区', NULL, '上海市徐汇区东南街道23号', NULL, 0),(93, '北京', '123', '18913526213', NULL, 36, '西城区', NULL, '123123', NULL, 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`com_like` WRITE;
DELETE FROM `yiji`.`com_like`;
INSERT INTO `yiji`.`com_like` (`com_like_id`,`product_comm_id`,`user_id`,`color`) VALUES (98, 34, 16, 'red'),(99, 33, 16, 'red'),(101, 35, 15, 'red'),(102, 33, 15, 'red'),(103, 34, 15, 'red'),(104, 36, 15, 'red'),(105, 37, 14, 'red'),(106, 38, 16, 'red'),(107, 39, 27, 'red'),(109, 41, 23, 'red'),(110, 41, 14, 'red'),(111, 42, 14, 'red'),(112, 34, 27, 'red'),(113, 43, 27, 'red'),(114, 52, 15, 'red'),(115, 51, 15, 'red'),(116, 55, 32, 'red'),(117, 56, 15, 'red'),(118, 61, 15, 'red'),(119, 61, 27, 'red');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`favorites` WRITE;
DELETE FROM `yiji`.`favorites`;
INSERT INTO `yiji`.`favorites` (`favorite_id`,`user_id`,`favorite_time`,`goods_id`,`goods_img`,`goods_price`,`goods_title`,`favorite_state`) VALUES (646, 15, NULL, 19, 'https://www.uniqlo.cn/hmall/test/u0000000029286/main/first/1000/1.jpg', 299.00, '\r\n女装 高级轻型羽绒便携式背心 轻暖便携防水(马甲) 440954', 1),(656, 15, NULL, 184, 'https://www.uniqlo.cn/hmall/test/u0000000023275/main/first/561/1.jpg', 399.00, '男装 快干轻型茄克(西装 外套) 437160', 1),(689, 15, NULL, 175, 'https://www.uniqlo.cn/hmall/test/u0000000030558/main/first/1000/1.jpg', 999.00, '男装 无缝羽绒大衣(外套 防风 防水 轻量 加厚) 442145', 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`goods` WRITE;
DELETE FROM `yiji`.`goods`;
INSERT INTO `yiji`.`goods` (`goods_id`,`goods_title`,`goods_details`,`goods_price`,`goods_scire`,`is_delete`,`goods_img`,`goods_date`,`goods_discount`,`goods_sales`,`goods_collection`,`goods_browse`,`goods_size`) VALUES (1, '男装/女装 法兰绒衬衫(长袖秋季休闲轻薄外套纯色) ', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027967/main/first/561/1.jpg', '2021-10-29 20:11:06', b'1', NULL, 50, 123, NULL),(2, '男装/女装/情侣装 牛仔衬衫(长袖休闲初秋薄外套) 443765', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027554/main/first/561/1.jpg', '2021-10-29 20:11:09', NULL, NULL, 100, 124, NULL),(3, '男装/女装 优质长绒棉衬衫(长袖休闲) 439611', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027211/main/first/561/1.jpg', '2021-10-29 20:11:12', NULL, NULL, 200, 456, NULL),(4, '男装/女装/情侣装 弹力斜纹宽松衬衫(长袖休闲薄外套) 439615', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000027874/main/first/561/1.jpg', '2021-10-29 20:11:13', NULL, NULL, 300, NULL, NULL),(5, '女装 精纺美利奴圆领针织衫(五分袖纯羊毛毛衣) 443436 ', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027492/main/first/561/1.jpg', '2021-10-29 20:11:17', NULL, NULL, 500, NULL, NULL),(6, '女装 针织背心(宽松基础款休闲百搭早秋多色叠穿) 439144  ', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030676/main/first/561/1.jpg', '2021-10-29 20:11:33', NULL, NULL, NULL, 500, NULL),(7, '女装 精纺美利奴羊毛罗纹V领针织开衫(长袖毛衣外套) 443843  ', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029361/main/first/561/1.jpg', '2021-10-29 20:11:36', NULL, NULL, NULL, NULL, NULL),(8, '女装 精纺美利奴圆领针织衫(长袖早秋纯羊毛毛衣) 439149 ', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029263/main/first/561/1.jpg', NULL, NULL, 1, NULL, NULL, NULL),(9, '女装 精纺美利奴两翻领针织衫(长袖早秋纯羊毛毛衣) 439153', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030676/main/first/561/1.jpg', NULL, NULL, 2, NULL, 600, NULL),(10, '女装 运动拉链连帽开衫(长袖 卫衣) 初秋', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028013/main/first/561/1.jpg', NULL, NULL, 3, NULL, NULL, NULL),(11, '女装 休闲西装(秋季外套 英伦)', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027645/main/first/561/1.jpg', NULL, b'1', 4, NULL, NULL, NULL),(12, '女装 绒面针织衬衫式茄克（薄外套 秋季新款', NULL, '249.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000028625/main/first/1000/1.jpg', NULL, NULL, 4, NULL, NULL, NULL),(13, '\r\n女装 宽松连帽外套(秋季新款 防风防水 休闲 户外) 439698', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027511/main/first/1000/1.jpg', NULL, NULL, 6, NULL, 8000, NULL),(14, '女装 高性能复合短大衣(外套) 439711', NULL, '599.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030559/main/first/1000/1.jpg', NULL, NULL, NULL, 121, NULL, NULL),(15, '秋冬女装 仿羊羔绒摇粒绒休闲拉链外套(保暖抓绒) 441833', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030531/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(16, '【设计师合作款UNIQLO U】女装 衬衫式茄克(外套) 442824', NULL, '599.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029606/main/first/1000/1.jpg', NULL, NULL, 7, NULL, 756, NULL),(17, '女装 精纺美利奴V领针织衫(长袖早秋纯羊毛毛衣薄衫) 441187                                                                ', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029468/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(18, '女装 高级轻型羽绒休闲茄克 轻暖便携防水(外套) 439707', NULL, '399.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029324/main/first/1000/1.jpg', NULL, b'1', 8, 1314, NULL, NULL),(19, '\r\n女装 高级轻型羽绒便携式背心 轻暖便携防水(马甲) 440954', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029286/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, 78725, NULL),(20, '\r\n女装 无缝羽绒连帽外套(大衣) 440950', NULL, '899.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030556/main/first/1000/1.jpg', NULL, NULL, 40, NULL, NULL, NULL),(21, '女装 高性能复合短大衣(外套) 439711', NULL, '599.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030559/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, 8775, NULL),(22, '\r\n【设计师合作款】女装 高性能复合宽松连帽外套 443185', NULL, '799.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030113/main/first/1000/1.jpg', NULL, NULL, NULL, 12000, NULL, NULL),(23, '\r\n女装 无缝羽绒长大衣(秋冬 外套) 429468', NULL, '999.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000020369/main/first/1000/1.jpg', NULL, NULL, 515, NULL, NULL, NULL),(24, '\r\n女装 高级轻型羽绒连帽大衣 轻暖便携防水(外套) 439709', NULL, '799.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030366/main/first/1000/1.jpg', NULL, b'1', NULL, NULL, 5876, NULL),(25, '女装 高级轻型羽绒背心 轻暖便携防水(马甲 外套) 443198', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029121/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(26, '女装 麻混纺休闲西装(春夏 外套 通勤) 433646', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000024474/main/first/1000/1.jpg', NULL, NULL, 4, NULL, NULL, NULL),(27, '【合作款UNIQLO U】女装 BLOCKTECH短款风衣(外套) 442823', NULL, '599.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029577/main/first/1000/1.jpg', NULL, NULL, 7, NULL, NULL, NULL),(28, '\r\n【设计师合作款UNIQLO U】女装 风衣(外套) 444021', NULL, '799.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029601/main/first/1000/1.jpg', '2021-10-29 20:11:48', NULL, 7, NULL, 23737, NULL),(29, '\r\n【设计师合作款UNIQLO U】女装 风衣(外套 秋季新款) 439697', NULL, '799.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029609/main/first/1000/1.jpg', '2021-10-29 20:11:45', b'1', 9, NULL, NULL, NULL),(30, '\r\n【设计师合作款】女装 法式粗花呢西装(秋冬 外套) 442904', NULL, '799.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028921/main/first/1000/1.jpg', '2021-10-29 20:11:47', NULL, 5, NULL, NULL, NULL),(31, '\r\n【设计师合作款】女装 法式粗花呢西装 (外套 格纹) 442904', NULL, '799.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028923/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(32, '【设计师合作款】女装 法式羊毛混纺西装(秋冬外套) 442899', NULL, '799.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028877/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(33, '\r\n【设计师合作款】女装 法式粗花呢西装(秋冬 外套) 442904', NULL, '799.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000028866/main/first/1000/1.jpg', NULL, NULL, 4, NULL, NULL, NULL),(34, '\r\n女装 轻型法兰绒格子衬衫(长袖休闲初秋轻薄外套)441154/441155/440605/441153 441156', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029906/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(35, '\r\n女装 轻型法兰绒衬衫(长袖休闲初秋轻薄外套)443520 439741', NULL, '149.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029909/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(36, '\r\n女装 花式衬衫长袖通勤职业“优衣库云朵衫”439730 433604', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000025285/main/first/1000/1.jpg', NULL, b'1', NULL, 800, NULL, NULL),(37, '【11.11预售】女装 花式条纹衬衫(长袖通勤职业百搭) 442462', NULL, '129.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028283/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(38, '\r\n女装 SUPIMA COTTON弹力衬衫(长袖通勤职业) 439738', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029258/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(39, '\r\n女装 SUPIMA COTTON弹力条纹衬衫 (长袖通勤职业) 441160', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029257/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(40, '【合作款UNIQLO U】女装 轻型法兰绒长衬衫(长袖休闲) 442468', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029584/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(41, '\r\n【设计师合作款】女装 法式法兰绒衬衫(长袖) 442730', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028915/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(42, '女装 柔软针织圆领套头衫(”百搭”长袖 毛衣 秋冬) 439142', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030031/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(43, '\r\n秋冬女装 弹力摇粒绒套头衫(保暖抓绒 百搭) 440266', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030823/main/first/1000/1.jpg', NULL, NULL, NULL, 970, NULL, NULL),(44, '\r\n女装 棉质罗纹短开衫(长袖初秋 辣妹风开衫) 446249', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029024/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(45, '\r\n女装 罗纹高领T恤(”搭配叠穿” 长袖 秋冬) 445629', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030018/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(46, '\r\n清凉黑科技女装 AIRism U领T恤(短袖 舒爽内衣 凉感) 432462', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023688/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(47, '\r\n【UNIQLO U】女装 圆领T恤春夏短袖“好感T” 435193', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000022271/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(48, '\r\n女装 柔滑棉质蝙蝠袖T恤(七分袖) 初秋 441832', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027997/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(49, '\r\n女装 SUPIMA COTTON圆领T恤(纯色打底短袖)441876 433577', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000022488/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(50, '\r\n女装 花式条纹半开领衬衫(“优衣库云朵衫”) 439729', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000022189/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(51, '女装 法兰绒格子衬衫(长袖) 432609', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000017736/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(52, '女装 花式半开领衬衫(七分袖)(“优衣库云朵衫”) 435014', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027629/main/first/1000/1.jpg', NULL, NULL, NULL, 1000, NULL, NULL),(53, '\r\n女装 乔其纱印花荷叶领衬衫(长袖 新云朵衫) 443345', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000028849/main/first/1000/1.jpg', NULL, b'1', NULL, NULL, NULL, NULL),(54, '女装 优质长绒棉开领衬衫(短袖) 438329', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000024478/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(55, '\r\n女装/情侣装 麻混纺开领衬衫(夏季短袖轻薄) 435018', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000023283/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(56, '\r\n女装 丝缎触感衬衫(短袖 圆领 通勤 气质) 434440', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026242/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(57, '\r\n【设计师合作款】女装 全棉宽松衬衫(春夏 七分袖) 437382', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000025711/main/other3/1000/4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(58, '\r\n秋季新款 女装 高腰牛仔九分裤(高腰神裤 显瘦显高) 439469', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027848/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(59, '\r\n秋季新款 女装 高弹力高腰牛仔裤(高腰神裤 百搭) 439217', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026982/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(60, '\r\n女装 HEATTECH高弹力高腰紧身牛仔裤(水洗产品(显高) 439207', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030375/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(61, '秋季新款女装 高腰锥形破洞牛仔裤(高腰神裤) 445646', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028564/main/first/1000/1.jpg', '2021-10-29 20:12:12', NULL, NULL, NULL, NULL, NULL),(62, '\r\n秋季新款女装 高腰锥形牛仔裤(高腰神裤) 444853', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028563/main/first/1000/1.jpg', '2021-10-29 20:12:14', NULL, NULL, NULL, NULL, NULL),(63, '秋季新款 女装 高腰喇叭牛仔裤(水洗产品) 445572', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029716/main/first/1000/1.jpg', '2021-10-29 20:12:17', NULL, NULL, NULL, NULL, NULL),(64, '女装 高腰喇叭牛仔裤(水洗产品高腰美腿裤 短款) 446815', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030010/main/first/1000/1.jpg', '2021-10-29 20:12:18', NULL, NULL, NULL, NULL, NULL),(65, '女装 高弹力牛仔长裤 (“优衣库高弹裤”)', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000021461/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(66, '女装 丝缎触感直筒裤 438067', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000022842/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(67, '\r\n女装 高弹力运动九分裤 物理防蚊裤 433737', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000022122/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(68, '\r\n春秋【UNIQLO U】女装 宽松牛仔裤(“神”裤 )446243 437055', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000022730/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(69, '\r\n女装 高弹力绒面松紧长裤(懒人裤 喇叭裤) 439108', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029071/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(70, '女装 绒面针织直筒裤(街头新潮裤 初秋) 439477', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029101/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(71, '女装 柔软针织松紧长裤 441795', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030140/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(72, '瞬间防晒女 AIRism防紫外线运动瑜伽紧身裤 内长60.5cm 433741', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000021633/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(73, '女装 棉质束脚裤 (潮流裤) 437807', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000022382/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(74, '女装 牛仔短裤(夏季 水洗产品) 437056', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000022758/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(75, '女装 麻棉短裤(夏季 休闲时尚 轻薄透气) 433269', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000024452/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(76, '女装 棉麻松紧短裤 437126 434915', NULL, '59.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026661/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(77, '女装 高腰牛仔短裤(夏季 水洗产品) 438852', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000025821/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(78, '女装 雪纺侧开叉裙裤(半身裙) 438099', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000022862/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(79, '女装 短裤 夏季(优衣库聪明裤 通勤)', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000024430/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(80, '女装/亲子装 (UT) PAUL & JOE休闲短裤(夏季碎花) 440031', NULL, '59.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000027132/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(81, '女装 花式蝴蝶结短裤(夏季) 436565', NULL, '79.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000023719/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(82, '\r\n女装 法兰绒衬衫式连衣裙(长袖)初秋 两穿 441150', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000028649/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(83, '女装 柔软法兰绒喇叭连衣裙(长袖) 初秋 两穿 444045', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000027986/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(84, '女装 美利奴羊毛混纺A字型连衣裙(“灯笼袖” 长袖秋冬) 440660', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030051/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(85, '\r\n女装 绒面针织背心裙 （初秋 百搭） 446552', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029290/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(86, '\r\n女装 印花V领喇叭连衣裙(七分袖法式气质)初秋 439752', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000027705/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(87, '\r\n女装 印花前排扣抽绳连衣裙(七分袖初秋附内搭) 443728', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029021/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(88, '女装 花式针织碎花印花甜美连衣裙(短袖 不易起皱) 438442', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000025349/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(89, '\r\n女装 花式格纹喇叭连衣裙(短袖夏季气质法式 附内搭) 442697', NULL, '149.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026510/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(90, '男装/女装/情侣装 可机洗宽松圆领背心433838 438782', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028301/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(91, '男装/女装/情侣装 可机洗宽松V领背心439928 443918', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028317/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(92, '男装/女装 souffle yarn半拉链针织衫(长袖毛衣) 438780', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029694/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(93, '男装/女装 souffle yarn针织开衫(长袖毛衣) 438794', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029710/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(94, '男装 圆领针织衫(长袖毛衣) 438795', NULL, '249.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030061/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(95, '男装/女装 圆领针织衫(长袖毛衣) 442741', NULL, '249.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030028/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(96, '男装/女装 柔软绵羊毛圆领针织衫(长袖毛衣) 438789', NULL, '249.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029243/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(97, '男装/女装 柔软绵羊毛V领针织开衫(长袖毛衣薄外套) 438790', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029267/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(98, '男装/女装 法兰绒衬衫(长袖秋季休闲轻薄外套纯色) 441070', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027967/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(99, '男装/女装 法兰绒格子衬衫(长袖秋季休闲轻薄外套) 441775', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027885/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(100, '男装/女装 法兰绒格子衬衫(长袖秋季休闲轻薄外套) 441776', NULL, '149.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000027878/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(101, '男装/女装 法兰绒格子衬衫(长袖秋季休闲轻薄外套) 441777', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027879/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(102, '\r\n男/女/情侣装 牛仔衬衫(水洗产品)(长袖) 438480', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000021666/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(103, '男装 条纹工装衬衫(水洗产品)(长袖休闲初秋薄外套) 443219', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027536/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(104, '男装 优质长绒棉衬衫(“优衣库学长衫”) 433470', NULL, '149.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000022192/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(105, '男装/女装 优质长绒棉衬衫(长袖休闲) 439611', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027211/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(106, '男装 高性能修身防皱衬衫(长袖商务职业“优衣库高效衫”) 436351', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000021599/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(107, '男装 高性能修身防皱衬衫(长袖商务职业“优衣库高效衫”)', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000021590/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(108, '男装 牛津纺衬衫(长袖 商务职业通勤休闲) 433472', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000021529/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(109, '男装 牛津纺条纹衬衫(长袖 商务职业通勤休闲) 436406', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000021662/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(110, '男装 牛津纺修身衬衫(长袖 商务职业通勤休闲) 441735', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026224/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(111, '男装 牛津纺衬衫(长袖 商务职业通勤休闲) 439612', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000026621/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(112, '男装 精纺弹力修身格子衬衫(长袖商务职业) 441687', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027216/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(113, '男装 精纺弹力修身提花衬衫(长袖商务职业“优衣库高效衫”)', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000021661/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(114, '男装 牛津纺修身条纹衬衫(长袖) 441736', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027872/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(115, '男装 牛津纺条纹衬衫(长袖商务职业通勤休闲) 441734', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027744/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(116, '男装/女装 法兰绒宽松格子衬衫(长袖) 442951', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029579/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(117, '男装/女装 牛仔宽松衬衫(水洗产品长袖) 442944', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000028340/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(118, '男装 牛津纺条纹衬衫(长袖 商务职业通勤休闲) 436406', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000021662/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(119, '男装 灯芯绒宽松立领衬衫(长袖薄外套) 442354', NULL, '199.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029302/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(120, '男装 牛津纺修身衬衫(长袖 商务职业通勤休闲) 441735', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026224/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(121, '男装 牛津纺条纹衬衫(长袖 商务职业通勤休闲) 436406', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000021662/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(122, '男装/女装 弹力修身牛仔裤(水洗产品) 425299', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000013099/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(123, '春秋款男装 弹力修身牛仔裤(水洗产品-赤耳丹宁) 430270', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000018149/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(124, '春秋款男装 修身牛仔裤(水洗产品) 433326', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000022193/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(125, '男装 EZY DENIM牛仔裤(水洗产品)(“神”裤) 433327', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000021890/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(126, '男装/女装 束脚运动裤(牛仔水洗产品潮流裤抽绳) 444564\r\n11/1-11/3活动商品，活动价199元', NULL, '249.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000027875/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(127, '\r\n男装/女装 束脚运动裤(街头新潮裤 牛仔 水洗产品) 444565', NULL, '249.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000028634/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(128, '春秋款男装 休闲直筒牛仔裤(水洗产品时尚宽腿) 441745', NULL, '299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026502/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(129, '\r\n男装 HEATTECH高弹力修身牛仔裤(水洗产品) 428903', NULL, '149.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000019775/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(130, '男装 AIRism针织松紧短裤(夏季凉感速干薄款) 443455', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027372/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(131, '男装 工装短裤(中裤薄款) 434857', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000024663/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(132, '男装 DRY-EX吸湿排汗短裤(中裤) 422966', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000014978/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(133, '男装 抽绳针织松紧短裤(中裤五分夏季休闲条纹薄款) 440347', NULL, '59.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000026512/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(134, '春夏男装 抽绳针织松紧短裤(中裤五分休闲牛仔薄款) 434988', NULL, '59.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023318/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(135, '【Theory联名款】男装 高弹力运动中裤（夏季） 441001', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000026304/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(136, '男装/女装 全棉短裤(中裤薄款) 434849', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027142/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(137, '男装/女装 全棉短裤(中裤薄款) 434849', NULL, '199.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000023813/main/first/1000/1.jpg', NULL, b'1', NULL, NULL, NULL, NULL),(138, '男装 易打理快干轻型长裤(修身 内裆长85cm 弹力) 437252', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023048/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(139, '男装 易打理快干轻型长裤（修身 内裆长76cm 弹力) 437252', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023074/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(140, '男装/女装 弹力舒适长裤 434862', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000023745/main/other3/1000/4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(141, '【设计师合作款】男装 +J 快干运动长裤 445159\r\n', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030974/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(142, '男装 快干弹力松紧短裤(中裤 春夏) 424145', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000014985/main/other3/1000/4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(143, '男装 快干弹力松紧短裤 424146', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000014870/main/first/1000/1.jpg', NULL, b'1', NULL, NULL, NULL, NULL),(144, '男装 秋冬款高弹力紧身牛仔裤(水洗产品) 439176', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027859/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(145, '\r\n男装 高弹力紧身彩色长裤(水洗产品) 444589', NULL, '249.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000031352/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(146, '男装 精纺美利奴针织POLO衫(长袖毛衣纯绵羊毛) 438788', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028213/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(147, '男装 DRY-EX吸湿排汗POLO衫(短袖 T恤) 433041', NULL, '79.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023311/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(148, '\r\n男装 DRY-EX吸湿排汗 POLO衫(短袖) 422962', NULL, '59.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000025964/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(149, '清凉黑科技 男装 AIRism POLO衫(短袖)(凉感衣 T恤) 435813', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023684/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(150, '清凉黑科技 男装 AIRism POLO衫(短袖 凉感衣 T恤) 436181', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023801/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(151, '男装 快干POLO衫(短袖) 441603', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028824/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(152, '男装 DRY-EX POLO衫(短袖) 422962', NULL, '39.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000017323/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(153, '男装 RF DRY-EX POLO衫(短袖吸湿排汗) 426625', NULL, '249.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000027212/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(154, '男装 柔软圆领T恤(长袖) 419496', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000017924/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(155, '男装 柔软圆领T恤(长袖初秋) 440524', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029027/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(156, '男装 柔软高领T恤(长袖初秋) 440525', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000029026/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(157, '男装 柔软两翻领T恤(长袖初秋) 440526', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029066/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(158, 'HEATTECH黑科技保暖衣 轻舒暖男装 T恤圆领（九分袖） 441620', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030193/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(159, 'HEATTECH黑科技保暖衣 轻舒暖男装 T恤高领温暖护颈 441625', NULL, '99.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030141/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(160, 'HEATTECH黑科技保暖衣 轻舒暖男装 T恤V领(九分袖） 441622', NULL, '99.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030195/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(161, 'HEATTECH黑科技保暖衣 多舒暖加棉男装 T恤圆领九分袖', NULL, '149.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030381/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(162, '\r\n男装/女装 罗纹背心 422988', NULL, '39.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000014411/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(163, '男装/女装 罗纹背心(纯色秋冬打底) 433027', NULL, '39.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023714/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(164, '清凉黑科技 男装 AIRism网眼背心(凉感内衣透气速干) 434431', NULL, '59.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023696/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(165, '清凉黑科技 男装 AIRism棉混纺背心(舒爽/凉感内衣) 426289', NULL, '69.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000015318/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(166, '清凉黑科技 男装 AIRism棉混纺背心(凉感 舒爽内衣) 434168', NULL, '59.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023468/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(167, '男装 DRY-EX吸湿排汗背心 437410', NULL, '59.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000025781/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(168, '男装 FUTURA DRY-EX吸湿排汗半拉链T恤(短袖夏季) 442839', NULL, '59.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000026487/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(169, '男装/女装/亲子装 条纹T恤(春夏季短袖) 438092', NULL, '39.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023780/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(170, '男装 高级轻型羽绒连帽外套(3D CUT轻暖便携防水) 439806', NULL, '599.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029277/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(171, '男装/女装 高级轻型羽绒背心(马甲轻暖便携防水防静电) 439807', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029321/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(172, '男装 高性能复合连帽外套(大衣 防风 防水 加厚) 439999', NULL, '799.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030554/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(173, '男装 高性能复合大衣(外套 防风 防水 加厚) 442144', NULL, '799.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030555/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(174, '【设计师合作款】男装 高性能复合宽松连帽外套 442563\r\n', NULL, '899.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030097/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(175, '男装 无缝羽绒大衣(外套 防风 防水 轻量 加厚) 442145', NULL, '999.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030558/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(177, '男装 无缝羽绒连帽外套(3D 大衣防风防水轻量加厚) 442147', NULL, '999.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030557/main/first/1000/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(178, '【合作款UNIQLO U】男装/女装 羊毛混纺茄克(外套) 442175', NULL, '799.0', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029587/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(179, '【合作款UNIQLO U】男装/女装 休闲茄克(外套) 442177', NULL, '499.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029588/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(180, '男装 风衣(外套) 442151', NULL, '899.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030363/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(181, '男装 插肩袖大衣(外套) 442152', NULL, '599.0', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030363/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(182, '男士风衣(外套) 442150', NULL, '599.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000028624/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(183, '男装 弹力毛料修身茄克(西装外套) 439586', NULL, '999.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000028289/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(184, '男装 快干轻型茄克(西装 外套) 437160', NULL, '399.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023275/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(185, '男装 快干轻型茄克(西装 外套) 433425', NULL, '399.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000023320/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(186, '男装 无缝羽绒连帽外套(3D 大衣防风防水轻量加厚) 442147', NULL, '999.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030557/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(187, '男装 高级保暖羽绒大衣(外套) 442146', '', '1299.00', NULL, b'0', '	https://www.uniqlo.cn/hmall/test/u0000000030817/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(188, '男装 无缝羽绒大衣(外套 防风 防水 轻量 加厚) 442145', NULL, '999.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030558/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(189, '【设计师合作款】男装 高性能复合宽松连帽外套 442563', NULL, '899.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030097/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(190, '男装 高级轻型羽绒茄克(3D CUT 外套轻暖便携防水) 439589', NULL, '599.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029269/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(191, '男装 高级轻型羽绒茄克(弧形压线 外套) 443879', NULL, '599.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000030379/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(192, '男装 高级轻型羽绒连帽外套(3D CUT轻暖便携防水) 439806', NULL, '599.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029277/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),(193, '高级轻型羽绒背心(马甲轻暖便携防水防静电) 439807', NULL, '299.00', NULL, b'0', 'https://www.uniqlo.cn/hmall/test/u0000000029321/main/first/561/1.jpg', NULL, NULL, NULL, NULL, NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`goods_eval` WRITE;
DELETE FROM `yiji`.`goods_eval`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`like_tb` WRITE;
DELETE FROM `yiji`.`like_tb`;
INSERT INTO `yiji`.`like_tb` (`like_id`,`theme_id`,`user_id`,`color`) VALUES (366, 2, 15, 'red'),(368, 29, 36, 'red'),(371, 78, 23, 'red'),(372, 29, 23, 'red');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`order_details` WRITE;
DELETE FROM `yiji`.`order_details`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`orders` WRITE;
DELETE FROM `yiji`.`orders`;
INSERT INTO `yiji`.`orders` (`orders_id`,`orders_addressID`,`orders_total`,`user_id`,`orders_goodsid`,`orders_goods_img`,`orders_goods_title`,`orders_goods_price`,`orders_goods_count`,`orders_goods_size`,`orders_pay_state`,`orders_payed_view_state`) VALUES (00000000000000001131, NULL, NULL, 15, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000030558/main/first/561/1.jpg', '男装 无缝羽绒大衣(外套 防风 防水 轻量 加厚) 442145', 999.00, 4, 'L', 1, 1),(00000000000000001162, NULL, 799.00, 15, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000030555/main/first/1000/1.jpg', '男装 高性能复合大衣(外套 防风 防水 加厚) 442144', 799.00, 1, 'XL', 1, 1),(00000000000000001199, NULL, NULL, 15, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000030558/main/first/1000/1.jpg', '男装 无缝羽绒大衣(外套 防风 防水 轻量 加厚) 442145', 999.00, 1, 'M', 1, 1),(00000000000000001202, NULL, 799.00, 15, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000029609/main/first/1000/1.jpg', '\r\n【设计师合作款UNIQLO U】女装 风衣(外套 秋季新款) 439697', 799.00, 2, 'XL', 1, 0),(00000000000000001203, NULL, 999.00, 27, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000020369/main/first/1000/1.jpg', '\r\n女装 无缝羽绒长大衣(秋冬 外套) 429468', 999.00, 1, 'M', 1, 1),(00000000000000001204, NULL, 5392.00, 16, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000030558/main/first/1000/1.jpg', '男装 无缝羽绒大衣(外套 防风 防水 轻量 加厚) 442145', 999.00, 1, 'L', 1, 1),(00000000000000001205, NULL, 5392.00, 16, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000029277/main/first/1000/1.jpg', '男装 高级轻型羽绒连帽外套(3D CUT轻暖便携防水) 439806', 599.00, 2, 'L', 1, 1),(00000000000000001206, NULL, 5392.00, 16, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000029277/main/first/1000/1.jpg', '男装 高级轻型羽绒连帽外套(3D CUT轻暖便携防水) 439806', 599.00, 4, 'L', 1, 1),(00000000000000001207, NULL, 5392.00, 16, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000028921/main/first/1000/1.jpg', '\r\n【设计师合作款】女装 法式粗花呢西装(秋冬 外套) 442904', 799.00, 1, 'M', 1, 1),(00000000000000001209, NULL, NULL, 32, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000030556/main/first/1000/1.jpg', '\r\n女装 无缝羽绒连帽外套(大衣) 440950', 899.00, 1, 'M', 0, 0),(00000000000000001210, NULL, NULL, 32, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000024474/main/first/1000/1.jpg', '女装 麻混纺休闲西装(春夏 外套 通勤) 433646', 149.00, 1, 'L', 0, 0),(00000000000000001217, NULL, 298.00, 27, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000024474/main/first/1000/1.jpg', '女装 麻混纺休闲西装(春夏 外套 通勤) 433646', 149.00, 2, 'L', 1, 0),(00000000000000001221, NULL, 298.00, 36, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000027967/main/first/561/1.jpg', '男装/女装 法兰绒衬衫(长袖秋季休闲轻薄外套纯色) ', 149.00, 1, 'M', 1, 1),(00000000000000001222, NULL, 298.00, 36, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000027967/main/first/561/1.jpg', '男装/女装 法兰绒衬衫(长袖秋季休闲轻薄外套纯色) ', 149.00, 1, 'M', 1, 0),(00000000000000001242, NULL, 799.00, 23, NULL, '	https://www.uniqlo.cn/hmall/test/u0000000023283/main/first/1000/1.jpg', '\r\n女装/情侣装 麻混纺开领衬衫(夏季短袖轻薄) 435018', 79.00, 1, 'S', 1, 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`p_comm` WRITE;
DELETE FROM `yiji`.`p_comm`;
INSERT INTO `yiji`.`p_comm` (`product_comm_id`,`user_id`,`goods_id`,`product_detail`,`product_data`,`color`,`state`,`like_count`,`user_name`,`user_pic`) VALUES (69, 23, 55, '上课几点开', '2021-11-15 10:58:56', 'black', 0, 0, '田', 'upload_b843bf438190ace0e5962cf3e090a227');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`pics` WRITE;
DELETE FROM `yiji`.`pics`;
INSERT INTO `yiji`.`pics` (`pic_id`,`goods_id`,`pic_url`) VALUES (1, 1, '	https://www.uniqlo.cn/hmall/test/u0000000027967/detail/393/10.jpg'),(2, 1, 'https://www.uniqlo.cn/hmall/test/u0000000027967/detail/393/1.jpg'),(3, 1, 'https://www.uniqlo.cn/hmall/test/u0000000027967/detail/393/3.jpg'),(4, 1, 'https://www.uniqlo.cn/hmall/test/u0000000027967/detail/393/6.jpg');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`shopcart` WRITE;
DELETE FROM `yiji`.`shopcart`;
INSERT INTO `yiji`.`shopcart` (`shopcart_id`,`shopcart_count`,`shopcart_attribute`,`shopcart_goodsID`,`user_id`,`shopcart_addTime`,`shopcart_goods_img`,`shopcart_goods_price`,`shopcart_goods_title`,`checked`,`shopcart_goods_size`) VALUES (352, 2, NULL, 20, 15, NULL, 'https://www.uniqlo.cn/hmall/test/u0000000030556/main/first/1000/1.jpg', 899.00, '\r\n女装 无缝羽绒连帽外套(大衣) 440950', 0, 'XL');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`theme_design` WRITE;
DELETE FROM `yiji`.`theme_design`;
INSERT INTO `yiji`.`theme_design` (`theme_id`,`user_id`,`theme_title`,`pic_url`,`like_count`,`com_count`,`collection_count`,`forward_count`,`is_forward`,`forward_id`,`start_time`,`update_time`,`theme_content`,`color`) VALUES (1, 15, '6k真的值？？真实戴森空气净化暖风扇使用报告', 'https://ci.xiaohongshu.com/8ae56472-41d4-4141-a5a7-970a2ea58505?imageView2/2/w/540/format/jpg', 7, NULL, NULL, 0, NULL, NULL, '2021-11-14 20:55:56.794165', '2021-11-14 20:55:56.794165', '的房子，为着健康考虑，给自己安排了空气净化器。现在入手戴森空气净化暖风扇已经一个月了，和大家分享一些我的真实感受。的房子，为着健康考虑，给自己安排了空气净化器。现在入手戴森空气净化暖风扇已经一个月了，和大家分享一些我的真实感受。的房子，为着健康考虑，给自己安排了空气净化器。现在入手戴森空气净化暖风扇已经一个月了，和大家分享一些我的真实感受。的房子，为着健康考虑，给自己安排了空气净化器。现在入手戴森空气净化暖风扇已经一个月了，和大家分享一些我的真实感受。', 'black'),(2, 16, '美诺吸尘器美爆了，吸尘器的天花板了解下', '	https://ci.xiaohongshu.com/5e6dc787-4d3d-5d5b-ba9b-3786bdc1c4d5?imageView2/2/w/540/format/jpg', 4, NULL, NULL, 0, NULL, NULL, '2021-11-14 20:55:49.156274', '2021-11-14 20:55:49.156274', '我最近搬进了刚装修过的房子，为着健康考虑，给自己安排了空气净化器。现在入手戴森空气净化暖风扇已经一个月了，和大家分享一些我的真实感受。', 'black'),(3, 16, '拥有一只胃口超好的宝宝是什么体验～', 'https://ci.xiaohongshu.com/051a5b0a-1807-6f05-0f3c-da6921c0523c?imageView2/2/w/540/format/jpg', 1, NULL, NULL, 0, NULL, NULL, '2021-11-14 20:26:26.655328', '2021-11-14 20:26:26.655328', '宝宝食欲不振、腹泻、便秘、消化不良，还有可能是肠道功能不好，\r\n\r\n这时候可以还给宝宝食用益生菌调理肠道～\r\n\r\n我家宝贝就属于这一类\r\n\r\n所以我给宝宝喝了Ofmom益生菌，效果很好哦~这款益生菌是李艾同款啦~', 'black'),(4, 15, '轻熟龄肌双十一指南！速速码住这期干货内容', 'https://ci.xiaohongshu.com/52444c32-e0bd-4a82-119b-9a2b907239e4?imageView2/2/w/540/format/jpg', 3, NULL, NULL, 0, NULL, NULL, '2021-11-14 20:35:38.376066', '2021-11-14 20:35:38.376066', '听完之后果断入了一瓶咖啡因水光眼霜，现在双11期间，买咖啡因水光眼霜，送水润亮采眼霜5ml+水亮嘟嘟凝乳20ml。', 'black'),(5, 23, '手脚冰凉的小姐姐｜爱慕牛奶衣来疼你', 'https://ci.xiaohongshu.com/dbabfbb3-09a6-7608-198d-9f499ea26d3c?imageView2/2/w/540/format/jpg', 2, NULL, NULL, 0, NULL, NULL, '2021-11-14 20:32:22.356723', '2021-11-14 20:32:22.356723', '#秋冬穿搭 #舒适家居服 #保暖衣 #万能打底', 'black'),(6, 32, '将田间的美丽搬进城市', 'https://ci.xiaohongshu.com/f24a437f-2167-43ac-ab51-5ce0a7d9a9e0?imageView2/2/w/540/format/jpg', 3, NULL, NULL, 0, NULL, NULL, '2021-11-14 20:32:24.385905', '2021-11-14 20:32:24.385905', '一起享受丰收的喜悦', 'black'),(7, 23, '校园游记|用照片记录陪伴我四年的学校', 'https://ci.xiaohongshu.com/86ec54a6-5593-bd41-5120-45c7a649b250?imageView2/2/w/540/format/jpg', 1, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:53:57.201628', '2021-11-14 17:53:57.201628', '在一个秋高气爽的周末\r\n\r\n突发兴致 想用照片来记录陪伴了我四年的学校', 'black'),(8, 16, '开封美食｜女朋友爱的店就是这样', 'https://ci.xiaohongshu.com/221efc62-aec4-fcfb-9311-2388858759e4?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:53:58.707113', '2021-11-14 17:53:58.707113', '吃麻辣烫吗？\r\n\r\n有小熊冰沙甜品的那种', 'black'),(9, 15, 'ootd经久不衰的马丁靴与千鸟格搭配', 'https://ci.xiaohongshu.com/38837429-7f63-628f-8680-78d0bb79c713?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:00.122259', '2021-11-14 17:54:00.122259', '属于秋天的元素有太多太多了\r\n\r\n经典的千鸟格、酷酷的马丁靴！', 'black'),(10, 32, '海豚合拍|分享我与新萌友的小日常', '	https://ci.xiaohongshu.com/120f7a12-5b3a-ed81-66e4-3825782eea4c?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:01.310698', '2021-11-14 17:54:01.310698', '最近北京的天气超棒！风里有了秋天的味道 还有我最喜欢的秋日暖阳～出去走走就发现街边这种日常的生活气真的是好舒服，好适合带上萌友们一起散散心，再随便咔嚓两张就是氛围感大片的味道啦', 'black'),(11, 32, '复古风格彰显格调！参考这些搭配，你也能打造出自己的style', '	https://p7.itc.cn/images01/20211010/da8e94f16a174c1f8a99711ee1a82013.jpeg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:02.135290', '2021-11-14 17:54:02.135290', '复古风的打造方法十分多样。我们可以在针织衣上叠穿一些披肩，从而打造出一种随性自由的格调。除此之外，整体的套装也特别适合我们去塑造属于自己的纯粹美感。', 'black'),(12, 23, '男生秋季该穿什么西装？', '	https://images.shishang001.com/2021/08/8c400715215e348dc5943f8e090ce4ce.png', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:06.596519', '2021-11-14 17:54:06.596519', '这个秋天，每个男生都要试一下西装，霸道总裁上身展示你成熟稳重的魅力吧！下面我们就为朋友们推荐几款适合男生秋天穿的新款老牌西装。第一款，无奈。无奈款式不是很多，但是每一款都有不同的颜色可以选择，版型都是比较宽松的，更加休闲百搭。', 'black'),(13, 32, '收到了好久的裙子终于在七夕这天穿上了', 'https://wx3.sinaimg.cn/thumb150/6913e233gy1gtgjo2sevgj21w01w0u0x.jpg', 1, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:08.085189', '2021-11-14 17:54:08.085189', '收到了好久的裙子终于在七夕这天穿上了[桃花][桃花]不得不说Sunnie真的超会选哦！这就是专业时博的专业水平吗', 'black'),(14, 15, '\r\n首页\r\n社区精选\r\n业务合作\r\n视频上传\r\n创作者服务\r\n\r\n新闻中心\r\n关于我们\r\n社会责任\r\n加入我们\r\n中文\r\n秋冬日的温柔感,只想保持美丽~', 'https://ci.xiaohongshu.com/92ce029e-e0b6-9191-c0c3-a8ab0e8ecc83?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:09.273735', '2021-11-14 17:54:09.273735', '虽然我在南方，但是也抵不住怕冷的\r\n\r\n北方的小姐姐那就不用多说了\r\n\r\n穿的都是厚厚的', 'black'),(15, 16, '\r\n购物分享｜来自黑白灰的安全感', 'https://ci.xiaohongshu.com/a1815878-9fa1-e7ec-9392-5902b1c8bde3?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:10.519592', '2021-11-14 17:54:10.519592', '熟悉这个牌子因为Maddy针织\r\n\r\n上身颈线绝绝子 冬天当内搭很惊艳', 'black'),(16, 23, '近期购物分享,秋冬不止棕色系呀～', 'https://ci.xiaohongshu.com/ae23efe9-7b4a-a0bc-b64a-1467034d9d1c?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:11.640721', '2021-11-14 17:54:11.640721', '终于迎来了降温，\r\n\r\n我可太爱穿毛衣和大衣的季节啦！\r\n\r\n秋冬毛衣｜牛角扣大衣｜秋冬穿搭\r\n\r\n#小个子女生穿搭', 'black'),(17, 32, '学生党减龄穿搭,秋冬元气学院风‼️', 'https://ci.xiaohongshu.com/ffec23f8-f680-ceaf-9e17-cc0b2119708b?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:12.901794', '2021-11-14 17:54:12.901794', '今天是一期学生党元气减龄穿搭‼️\r\n\r\n甜系女孩必备～', 'black'),(18, 15, 'OOTD|学院风穿搭|西装套装穿搭 叮咚～', 'https://ci.xiaohongshu.com/a4cf806c-3a65-9f8e-061d-93d8752cf797?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:14.185167', '2021-11-14 17:54:14.185167', '饱饱今天给大家带来的校园风西装套装穿搭，又是早秋里回头率百分百，眼前一亮哦，大家快收集起来吧\r\n\r\n', 'black'),(19, 16, '小众辣妹!绝美纯御 设计师加鸡腿系列', 'https://ci.xiaohongshu.com/0154072f-5a07-4083-5d1c-72646e097cb6?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:15.234380', '2021-11-14 17:54:15.234380', '宝~来辣！\r\n\r\n今天又是一期小众原创设计品牌分享,独特&实穿的小众独立设计品牌\r\n\r\n双⑩①抢美衣怎么能少了TA呢', 'black'),(20, 23, 'OOTD卫衣穿搭|学生党这样穿显高又显瘦', 'https://ci.xiaohongshu.com/c1205a70-e48c-e3aa-0139-e811b4782bb3?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:16.448850', '2021-11-14 17:54:16.448850', '宝儿们，今天更新几套日常卫衣穿搭\r\n\r\n不管是学生党还是上班族都可以轻松驾驭！\r\n\r\n卫衣搭配牛仔裤，真的太绝了！\r\n\r\n简约清爽，随便找个外套都能搭\r\n\r\n不会搭配的妹子可以参考哦\r\n\r\n卫衣纯棉的料子，上身质感超级棒', 'black'),(21, 32, '冬季棉服韩系休闲穿搭', 'https://ci.xiaohongshu.com/3311c1eb-5453-fb26-b059-40b82d701ee0?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:19.204656', '2021-11-14 17:54:19.204656', '我觉得这个咖色有点好看\r\n\r\n最近气温下降 宝子们记得加衣服哦\r\n\r\n秋裤穿起来', 'black'),(22, 15, '气质清新穿搭冬日奶茶色', 'https://ci.xiaohongshu.com/8971792e-c867-5622-2a2d-ad5a5db38dfb?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:20.290282', '2021-11-14 17:54:20.290282', '哈喽我来啦～今天是气质小姐姐嘻嘻～让人看起来非常舒服又暖的外套～', 'black'),(23, 16, '双十一购物清单 | 区区欧阳 每期必入～', 'https://ci.xiaohongshu.com/69164c85-6b24-8c3f-264d-fbac6d045154?imageView2/2/w/200/h/200/q/75/format/webp', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:21.400904', '2021-11-14 17:54:21.400904', '这一波购物主要是衣服类的\r\n\r\n我回购过无数次的漂亮衣服店铺\r\n\r\n款式设计、质量 都在我心尖上 每期必入~\r\n\r\n详细的店铺信息 衣服细节都在图片上啦', 'black'),(24, 23, '毛衣有特色 | 糖果心情 神仙毛衣店铺合集', 'https://ci.xiaohongshu.com/f02746b3-0383-717d-1959-7d4a63e99e8e?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:22.733663', '2021-11-14 17:54:22.733663', '忍不住要推荐给大家的神仙毛衣店铺\r\n\r\n我真的太爱了！！！\r\n\r\n颜色漂亮设计鬼马', 'black'),(25, 32, 'OOTD | 平价又不显胖的羊羔毛太好穿了呀', '	https://ci.xiaohongshu.com/56db5fd2-c19d-91cc-f06b-c5ca1889b99b?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:27.484387', '2021-11-14 17:54:27.484387', '羊羔毛外套+无领的开衫设计\r\n\r\n真的超级实用！！\r\n\r\n不仅可以搭配打底长裤。\r\n\r\n连帽卫衣卫裤！连衣裙！毛衣！全部都', 'black'),(26, 15, 'OOTD | 31岁减龄穿搭 | 小个子美式校园风', '	https://ci.xiaohongshu.com/975952db-a1e8-8bbd-8306-975976f8b7fd?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:28.628525', '2021-11-14 17:54:28.628525', '休闲宽松的一套~\r\n\r\n关键还很实用！\r\n\r\n天冷可以里面套厚衣服\r\n\r\n搭配了休闲裤\r\n\r\n其实很少穿白色裤子\r\n\r\n但是这款发泡的卫裤真的hin好看\r\n\r\n边边是扣子的，而且印花是发泡的', 'black'),(27, 16, '小个子复古长裙穿搭 | 牛仔衣也太好看了呀', '	https://ci.xiaohongshu.com/ba42661a-53df-2944-abaf-e4fd3d10f029?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:29.829189', '2021-11-14 17:54:29.829189', '\r\n小个子复古长裙穿搭 | 牛仔衣也太好看了呀\r\n早上好\r\n\r\n复古风来啦！！\r\n\r\n穿上这一套我立马想起来我妈妈年轻的时候haha\r\n\r\n颜色也是敲适合秋天的呀\r\n\r\n牛仔衣修身款\r\n\r\n还有加送了腰带\r\n\r\n做内搭也hin好看！', 'black'),(28, 23, '\r\nOOTD | 小个子平价皮草穿搭,保暖叠穿法！', '	https://ci.xiaohongshu.com/2f3320da-b0cf-a2f7-a3e4-996fe02cfeb9?imageView2/2/w/540/format/jpg', 0, NULL, NULL, 0, NULL, NULL, '2021-11-14 17:54:30.985311', '2021-11-14 17:54:30.985311', '最近入的两件毛毛外套~\r\n\r\n都还挺不错哒！！\r\n\r\n不会显得很臃肿\r\n\r\n关键保暖', 'black'),(29, 15, '小个子秋季穿搭 | 基础毛衣叠穿保暖又好看', 'https://ci.xiaohongshu.com/bdb4be94-c933-45d1-3a23-66c68f759a58?imageView2/2/w/540/format/jpg', 3, NULL, NULL, 0, NULL, NULL, '2021-11-15 11:10:21.673233', '2021-11-15 11:10:21.673233', '日常出门的简单穿搭\r\n\r\n舒服100%\r\n\r\n里面搭配了针织衫\r\n\r\n外面还是针织衫\r\n\r\n两层厚实保暖！！\r\n\r\n老爹鞋+老爹裤\r\n\r\n休闲穿搭get', 'black'),(78, 23, '式神', 'https://www.uniqlo.cn/hmall/test/u0000000024474/main/first/1000/1.jpg', 1, NULL, NULL, 0, NULL, NULL, '2021-11-15 11:10:19.279378', '2021-11-15 11:10:19.279378', '圣诞节哦啊四季豆啊', 'black');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`theme_maincom` WRITE;
DELETE FROM `yiji`.`theme_maincom`;
INSERT INTO `yiji`.`theme_maincom` (`theme_mainCom_id`,`user_id`,`theme_id`,`com_content`,`com_time`,`like_count`,`user_name`,`user_pic`) VALUES (31, 23, 78, '是爱的就阿斯达斯', NULL, NULL, '田', 'upload_a05a44602ac689b2eaa794caa266a718');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `yiji`.`user` WRITE;
DELETE FROM `yiji`.`user`;
INSERT INTO `yiji`.`user` (`user_id`,`user_name`,`user_phone`,`user_sex`,`user_pwd`,`user_email`,`user_height`,`user_weight`,`user_birth`,`user_point`,`user_pic`) VALUES (15, '邵美薇', '15150137501', '女', '$2a$10$6ApRcP80VeVKdV5ro6V4ROea8ejpMfqYt3ee7tLpiYYtHSxW0dkLq', NULL, 170, 110, '2021-11-10', NULL, 'upload_b005a87fa38968d7a0c98879e8b2f3a8'),(16, 'hejiahui', '18795720289', '女', '$2a$10$7IWMVmpzrQWkEc.HdZGA5uEv/vrC2HZLt/upjYbgno9xmH4bJa.MG', NULL, 238, 45, '2021-11-24', NULL, ''),(23, '田', '17739616787', NULL, '$2a$10$PxDRwim4iyskLLVbJDc7WOGnU8GV.IC3I3RdW/jHZuzJE/XOVnFaa', NULL, NULL, NULL, NULL, NULL, 'upload_a05a44602ac689b2eaa794caa266a718'),(27, '何heh', '18036109573', '女', '$2a$10$T8.10khjFFUdOLjRDCgWleMzDmZOnTMFvh06NW/Ym/vtBhIlOmu0C', NULL, 165, 60, '1999-09-29', NULL, 'upload_121987536d9f1774aad5e403f168f9ca'),(28, 'niudong', '15083069726', NULL, '$2a$10$TbpXNjWK26dIFd/ZQ8O8s.TPK9ebEsmTCRXFnaKIZS7iW4eEgik9.', NULL, NULL, NULL, NULL, NULL, ''),(29, '邵美薇', '19845914791', NULL, '$2a$10$sYUFehkyQQBUxW5llQVYgeDsQAH//bTz19fw2GVGYpdjEgn0nLRL6', NULL, NULL, NULL, NULL, NULL, ''),(32, '汪', '18913526213', '男', '$2a$10$0OP6x0z02q1e8q9ONNVU8Oesql5UBjmjA6jtksv1hK/s8tfEpvlZ6', NULL, 178, 130, '1999-05-26', NULL, 'upload_a328375db5a5fdb878ec8982657694b7'),(33, 'njw', '18112575025', NULL, '$2a$10$CMKGwibf4ty6acX5ViqHXeCMhcu7SkMklHji14WE0NqW6ib4Zc1B6', NULL, NULL, NULL, NULL, NULL, NULL),(36, '老大', '15150132305', '男', '$2a$10$QCn4MnxFv/nkSQ/cpdcEg.WAl82QHZJ0j0Yp8BjOs/hA/TYqK/JpK', NULL, 178, 120, '2020-06-10', NULL, 'upload_8fe54dab5d0f702da31805c55467a30d');
UNLOCK TABLES;
COMMIT;
